﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using SQLExecute;

/// <summary>
/// Summary description for specialized
/// </summary>
public class specialized
{
    private string _city_id;
    private int _school_id;
    private int _disciplines_id;
    private string _specialized_name;
    private DataSet ds;
	public specialized()
	{
		//
		// TODO: Add constructor logic here
		//
	}
    public string CityID
    {
        set { _city_id = value; }
        get { return _city_id; }
    }
    public int SchoolID
    {
        set { _school_id = value; }
        get { return _school_id; }
    }

    public int DisciplinesID
    {
        set { _disciplines_id = value; }
        get { return _disciplines_id; }
    }

    public string SpecializedName
    {
        set { _specialized_name = value; }
        get { return _specialized_name; }
    }

    public DataSet Get_List_Specialized()
    {

        ds = SqlHelper.ExecuteDataset(Common.strConnect, "Get_List_Specialized", new object[] { this._city_id, this._school_id, this._disciplines_id});
        
        return ds;
    }
    public void Insert_Specialized()
    {
        SqlHelper.ExecuteNonQuery(Common.strConnect, "Insert_Specialized", new object[] { this._city_id,this._school_id,this._disciplines_id,this._specialized_name});
    }


}
